package tech.aistar.mapper.position;

import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import tech.aistar.entity.City;

import java.util.List;

/**
 * @Author: lya
 * @Description: 本类的作用描述:
 * @CreateDate: 2019/10/3
 * @Version: 1.0
 */
@Repository
public interface CityMapper {

    /**
     *查询所有市
     */
    @Select("select * from city")
    List<City> findAll();

    /**
     * 通过ID查询市
     */
    @Select("select * from city where id = #{id}")
    City findById(Integer id);
}
